SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505780 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505780 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859459,189942,781517,509081,9022,940683,765392,706458,34322,624930,842957,905385,948964,860111,628004,977356,882710,385605,577215,63807,98518,552615,283041,528516,764914,945680,645141,1009489,1005686,270139,133869,74241,411199,92545,12242,332919,639762,735293,762125,848926,58997,45999,544841,461916,185184,88988,359868,689986,813736,613410,331803,992741,757605,570116,957283,1009070,338910,583953,618460,752548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]