SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594918 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594918 [ RunTime:0.002299s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599328,294810,820711,482248,161534,564205,505660,1023113,321284,721238,689737,60144,595360,894439,104583,566542,853885,593144,1026072,159692,730038,665272,233498,622561,696896,357607,359847,434305,969782,124885,843422,626065,912699,531109,406366,701884,518967,985215,879600,14438,643961,461504,503317,1018382,203099,139121,940614,574995,325842,732822,980600,389043,354123,561561,644837,770614,340823,944098,593214,960373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]