SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40800 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40800 [ RunTime:0.003110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650552,483265,10453,42708,800246,790892,887619,638774,147621,575102,823267,287265,801680,602452,943293,834443,867582,613263,602712,565618,90507,89520,385693,749148,633147,53742,34214,1028116,590947,870317,857599,640398,172491,675922,390235,381846,385882,649085,217717,520331,869724,664202,276567,62512,9665,340758,521293,260569,134792,590849,743942,99902,356909,880422,47614,742719,412034,976739,588299,459773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]