SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19508 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19508 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327569,874543,570597,1025136,1020629,1025132,592687,152731,881803,476276,444747,620284,462930,850838,410880,9698,76574,896107,15685,685614,729915,10779,601287,192514,1033066,75436,988136,684507,473224,358640,546321,150570,1021761,536541,198135,407794,12845,127138,401407,919595,288921,290940,275579,768166,71381,415712,452158,985047,19744,98872,364971,834106,824696,153557,538396,779076,154251,254451,236075,165442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]