SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007628 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007628 [ RunTime:0.002349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429739,874156,111493,539265,955449,873719,210927,189240,207751,795502,484603,1023172,818849,872149,824040,859882,290096,218237,886857,1026521,7380,197080,492670,850600,1025432,436436,652508,549439,538805,418784,835030,927927,447411,1000582,321438,201486,963773,192490,385621,939272,269714,995357,457050,997734,230168,838206,742656,160564,247397,238960,969270,660343,199484,355530,97481,738583,408313,418667,280040,606112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]