SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019471 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019471 [ RunTime:0.003188s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920129,368391,282069,681645,792471,927987,905519,85885,573374,498998,999274,37463,623705,288191,568974,123258,238556,130046,761776,516886,561742,108787,601159,383381,106818,926903,74575,412430,257334,706483,479538,457430,972366,303087,223467,937259,21588,473586,489601,405414,500732,41412,593451,313247,345437,364904,782320,968885,864306,300255,21011,528304,829118,832468,851977,510484,811438,131109,812694,350105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000754s ]