SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546213 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546213 [ RunTime:0.002575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165758,568111,868564,29462,412205,864641,401945,101554,695761,284624,754658,650423,661714,527888,563705,453,523056,90153,685573,397188,846737,1047303,261271,389340,993400,1002346,1046610,415494,212963,2295,138752,963363,1006679,185566,927153,776075,916453,327221,699575,407083,643090,78763,314604,64404,965541,279010,997162,512664,830927,214491,856709,914649,754112,701196,249983,978971,656447,594923,135158,332260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002586s ]