SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542280 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542280 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337043,358407,634139,916857,258951,336904,356971,755600,777499,337983,724815,334684,861851,716782,706578,365234,915336,1006733,405034,997990,275183,921822,231052,470611,861491,1045903,722595,168463,495866,533482,406650,97741,770629,1048411,485374,85208,295845,696692,806412,456769,172370,897418,312433,888038,380771,383801,680478,926063,1036704,95607,288264,165616,96847,100546,849990,790523,141647,471554,792694,724994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]