SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505152 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505152 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829912,1035517,300441,16857,353027,515900,209178,915599,521265,575209,344538,176213,132090,464746,310310,702955,274891,767121,145404,494911,991007,771955,952992,253414,312434,412123,600926,237268,764029,863589,767550,57558,658211,800560,570958,631688,604374,1029523,144829,649747,624944,318827,698589,244057,942934,90635,664729,525645,478221,641728,681396,495617,880488,138312,695760,401279,732777,712921,665182,857183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]