SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410022 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410022 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166419,101710,956441,305071,304892,685734,114986,498930,17960,612154,37795,710501,256413,504297,970198,781666,700705,356874,652279,294508,469001,138397,443074,59058,679701,927613,985788,241697,637543,881441,268399,744170,695079,192509,707998,403017,218514,810862,959827,474809,735854,454600,514111,753490,740058,641762,434576,575692,908319,938932,865296,278427,1014293,466683,767080,308413,565706,475747,172887,100758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002788s ]