SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103014 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103014 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226273,777781,87136,580935,762717,879199,871981,809579,581764,398122,930371,957403,124841,777024,270033,166048,903121,81213,45350,685132,43796,6843,801588,965023,100212,255226,293826,516526,344388,232600,414857,42655,669630,22173,384468,208315,45233,477538,272932,862801,194296,689530,35249,106303,469399,340472,384398,600170,545696,117409,546007,124574,373116,816365,575757,781351,577261,852048,495796,181235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]