SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402104 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402104 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909599,781358,141959,457582,1042315,855664,778860,515327,463652,79653,924134,642793,548211,954019,62380,301912,611313,285528,752576,426647,396014,375877,612565,536899,436381,792164,719838,572183,694253,965612,432838,719281,721903,285260,469303,251687,74741,369305,23266,282217,188886,795274,171168,398262,1036902,19212,351314,556857,637957,485928,234899,762646,873045,439558,369982,839667,710199,92674,322113,923270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]