SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554030 LIMIT 1 [ RunTime:0.000901s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554030 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437149,493556,751830,359734,997549,248268,144305,364002,112441,185079,236643,522111,370296,221866,540634,497423,490417,782963,657719,939895,687753,11376,1035779,377566,132241,515795,51074,131121,31991,533455,906959,875971,441734,103666,183390,509442,318990,984426,710535,359554,878040,829100,738199,1023484,214121,411207,337240,394701,345718,192792,504422,1043161,253318,630741,808182,616179,615503,888403,446647,167415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]