SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520461 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520461 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91300,266098,377653,508885,430569,285565,1028344,649534,832191,242572,984392,105487,691962,624493,25621,782293,306205,163336,979330,678148,311865,724986,617618,596872,64001,26565,507543,683316,758186,719760,963179,415718,480699,615437,300198,966280,775310,673679,332734,803304,598201,956628,689160,277319,9493,151262,918168,122995,747551,369551,739842,64652,731819,231431,752800,151213,513748,495679,47127,700499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]