SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001910s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50429 LIMIT 1 [ RunTime:0.004160s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50429 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374909,753718,313299,807714,547922,444174,152859,147048,214438,438826,482123,344456,378569,200311,48221,259572,997338,599442,857203,404324,281145,587110,67055,110539,536144,804481,83971,277326,690242,715111,978126,1021392,472277,737192,494169,799608,1025907,897789,464967,63704,516282,726070,537280,375934,601757,250167,447251,191297,163501,790875,748238,793159,86604,1003043,176380,600082,1029577,316315,583241,114901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]