SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410034 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410034 [ RunTime:0.002094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043261,658282,396107,147700,43556,349777,60418,791086,272325,776513,137856,335041,542588,13424,374519,670241,362598,815905,633381,69428,430491,641849,678629,671853,198708,528804,881840,15627,345784,687602,553754,23813,914467,323272,955142,1021551,717249,103630,677348,823016,345361,699356,78900,729563,196166,804475,191051,723404,346006,771676,486709,307097,175920,515949,958613,716293,909262,468818,906735,219705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000747s ]