SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231184 LIMIT 1 [ RunTime:0.001993s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231184 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100227,676109,80822,543091,972709,257390,235350,1020482,792336,118865,804641,255750,918521,541155,330795,955755,700634,832097,206964,1005195,806277,269948,975759,865713,62038,284733,273857,202141,111768,624584,85977,514299,687594,589618,317632,72527,868079,542897,345571,983750,809213,406817,379251,328561,690938,1017788,594341,639934,983618,598223,410121,188001,762191,664409,127157,83979,330195,28259,350802,1048048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000844s ]