SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 913001 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 913001 [ RunTime:0.003439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516808,1015867,697958,836966,688059,1027259,186157,399170,835050,225503,723272,60514,422460,898384,673021,507540,877178,388534,829541,1023324,740177,176125,57941,35269,366676,110375,188868,243441,17327,475036,735387,168826,546502,513285,377392,484858,990565,282023,179276,784299,694959,128723,620145,553220,973039,206492,399685,28349,488906,810850,66748,50094,930086,328088,541667,763259,365676,277849,924613,866017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 913001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 913001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000820s ]