SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402285 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402285 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490673,324354,781129,208950,1014966,708977,1024437,35486,350129,363814,782908,785932,448897,481964,147958,963608,85351,289173,831822,808293,27114,671972,979070,299259,991047,219158,472776,356963,568093,829052,483141,564717,363199,355170,859060,721704,553665,870446,44540,587961,482061,599982,292138,341580,642818,952828,745680,126817,664109,427049,1000421,694838,501348,1004900,680206,197078,409099,337410,695385,1017779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402285 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402285 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]