SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249913 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249913 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710922,727612,409272,957286,562041,158702,552772,298,500990,955892,236631,281982,206025,76869,600884,954886,782114,890956,869404,744473,826502,14912,1014326,196884,695059,874095,736768,138517,115864,531467,277060,716636,594580,355161,406633,221434,1028684,943035,421485,170532,739566,239787,396445,335932,811402,1000857,90281,1005578,494662,797815,445064,319423,611677,298292,611504,306372,646260,733847,726682,950797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002207s ]