SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599728 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599728 [ RunTime:0.003138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945014,1047521,198121,1014323,688704,929938,410943,148293,616326,26708,267455,820488,108127,962493,208519,993729,764923,554680,957001,417336,408752,1025127,163576,383051,333632,211132,144570,93397,287375,269000,637725,404775,202791,950037,254231,176906,177660,516556,337193,1030251,46645,273666,255237,830008,866711,960830,810769,304171,380846,525109,905170,71833,279630,633497,1008592,997070,312359,194052,1017555,566357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]