SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514551 LIMIT 1 [ RunTime:0.005056s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514551 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427159,766452,159954,935497,575571,430016,165300,427635,919769,1026531,262493,957363,856659,515200,65215,855303,104079,677414,79442,393542,267831,1022380,540881,120711,83518,502487,552351,553034,401969,811081,735644,224218,64162,966098,382393,381650,65017,231150,492685,19637,155531,438876,363391,204811,928524,364635,519658,634349,160450,964098,127899,356364,68075,385094,319985,239631,705987,231606,636339,804959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001502s ]