SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427918 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427918 [ RunTime:0.003499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506552,702167,118968,204875,876008,23602,940690,254427,912308,827313,693426,674938,34025,443861,148919,522016,29654,181532,342869,187145,748142,403299,567931,855345,636784,358674,154185,329539,115735,731644,718441,3345,973576,286910,385951,120904,635363,935427,976067,530335,205252,848911,989057,93020,535543,236324,643355,191065,883929,196067,133514,584382,813174,907888,321210,481401,405259,551544,280878,864441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]