SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003879s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027300 LIMIT 1 [ RunTime:0.002045s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027300 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347896,587686,702901,693245,350405,236295,237031,135392,941577,813891,150103,810593,853461,940357,100868,22012,897035,270454,793751,814804,298294,92093,375460,770605,246077,557955,317278,999440,42019,164885,638950,664542,1007213,169872,191976,314864,37612,433343,33390,157495,779006,608559,959822,360699,827958,544001,889850,271120,385048,209838,288907,168204,963461,359791,886355,8481,130341,428396,448141,772794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]