SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506912 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506912 [ RunTime:0.003353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337055,675790,302696,136038,202233,906530,554620,447482,1006820,1020933,100876,339971,246295,262123,771872,450243,953550,436751,1028001,826163,472325,883711,167321,293387,412534,806041,600543,376211,121611,1041945,796579,189023,1035867,180537,885800,881151,1024284,834501,179175,406358,1012921,373688,764993,798422,234459,816779,985404,545513,518224,643653,992442,467781,857496,455451,670257,29703,392833,176628,601323,16522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]