SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328461 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328461 [ RunTime:0.004624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905096,17718,544949,1036821,947046,643951,243558,537451,591387,344565,309251,183133,28127,679054,420502,856888,447861,432552,922000,267812,627856,90349,12262,839183,415503,514478,840006,245333,569536,614824,960008,693488,479700,166953,910964,777943,1016895,900338,360229,295439,1013604,1036818,671331,871106,101946,665610,326850,67949,662178,888810,247651,142917,767425,74389,569242,1008469,961692,609071,312016,870365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]