SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000919 LIMIT 1 [ RunTime:0.002315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000919 [ RunTime:0.006161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440721,579165,809935,921532,189865,266154,320487,1039563,1030981,635290,998543,680402,168680,550601,674638,436653,648845,839531,120450,70177,651309,488944,865860,931495,537828,508526,304850,951036,847887,288796,576280,558739,317507,67456,708372,874365,987718,130121,257403,156696,427744,103767,1023640,1019243,961975,929710,830789,160139,479099,152365,38533,930587,168300,529883,773221,646040,375741,787123,394804,218870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]