SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280203 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280203 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951671,52891,1027766,330583,44570,217169,497880,888893,1018369,704704,157116,640812,980952,481241,641748,592152,400512,1014144,168614,208391,1023016,11247,466990,831184,210761,957708,887687,333048,787861,849330,339248,173349,667395,867985,822637,987800,526582,268458,739541,996867,35284,104271,125723,881824,864363,394706,634190,598559,838617,299870,464218,418805,930100,209153,228969,979547,874626,926693,277273,856706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]