SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920529 LIMIT 1 [ RunTime:0.000549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920529 [ RunTime:0.002783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002313,378943,478017,422310,25150,538510,515488,139301,770395,752091,345371,762746,269966,72854,502520,771480,622770,605657,937777,601520,617160,147672,870742,60137,428436,434747,20951,386458,146386,98345,703403,718285,82000,730258,359055,531488,457808,729659,422691,546312,929506,903793,956837,881179,574390,178960,444748,310244,438553,791907,75516,285369,993242,755789,1009721,552044,1033382,626879,154768,74495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000891s ]