SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553445 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553445 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405079,922976,771236,282624,820063,169177,605610,912477,123568,1040658,955385,654900,397608,604291,804766,267012,348664,509645,89436,939254,575722,442281,213815,744580,659779,410734,92414,771791,105451,341569,221967,479744,601356,26446,129666,495088,17458,369649,688033,727824,309180,296566,1020130,114512,205783,428367,10173,77421,623480,190340,978402,975004,217624,140269,1034183,755938,1025496,107679,608858,184972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]