SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503716 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503716 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861175,738047,261937,633632,534118,928771,1810,771329,606521,269615,383777,135097,655807,826687,534208,602624,603191,104411,879916,928808,717883,654877,843261,765280,842836,448150,539550,391744,350067,960432,328421,141475,702339,326728,85113,843191,98762,758951,13657,571311,949765,803016,352183,923871,928281,134073,397535,994383,353809,92346,518691,175651,28682,160787,175923,557733,21440,1002933,919547,85099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]