SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407176 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407176 [ RunTime:0.003930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53068,567018,218864,1045975,155786,498569,42382,42564,239065,262168,610230,148247,653359,538517,421410,624779,464270,120571,513578,754997,507527,43308,201503,141030,340660,957073,253904,203212,317869,452493,109205,180097,76644,443226,201431,606863,603398,336448,1046715,957622,791300,1035640,421437,942631,137877,545711,886295,827224,582010,54386,96572,263107,890161,914625,1904,473384,841512,1005166,154757,1005355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]