SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102712 LIMIT 1 [ RunTime:0.000929s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102712 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341282,556895,409560,479794,855342,11910,234826,500139,118763,733895,843440,792519,619061,767483,263194,297756,17729,450317,865548,1012076,627511,7861,363710,74391,447326,495197,817182,80634,87257,457863,947484,958622,228416,414233,64648,713068,802680,813452,1025866,800958,315452,1014125,686200,1047101,35827,102898,441554,870334,919855,96776,648077,572700,55457,665834,136859,383359,226407,549519,635179,40731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003853s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]