SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351811 LIMIT 1 [ RunTime:0.001226s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351811 [ RunTime:0.002789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606693,993657,408557,481787,645919,845922,270511,956168,961222,657716,1005339,641081,414144,324869,869733,304686,12671,895256,685746,822682,215498,797991,634533,412254,34979,108027,318433,2195,215444,858913,218581,622980,651716,1006907,829711,195496,342710,783180,24698,725370,341879,213919,1010062,749484,570112,901761,56640,100098,706519,873131,455044,521151,509165,900876,345757,215175,867520,334952,334755,665828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]