SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26804 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26804 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678954,550661,306410,309841,503250,42907,326990,204686,495032,854504,393641,1867,790001,908129,519018,991480,223572,992433,947427,249534,769162,128718,345468,874841,941651,89211,94913,785250,89674,136935,963660,485676,498187,415562,395229,428485,1032491,77244,620734,136577,1018976,288153,849983,401631,522487,796554,1016140,537766,598224,414534,359943,664418,1033678,215265,727072,632683,697992,301335,74187,21791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]