SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 649043 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 649043 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414174,838630,302519,645188,438285,76412,1029356,441685,154070,271535,97822,407584,575133,337276,933084,667519,486668,820154,472233,453084,309420,968405,166612,1010948,840020,429791,1025674,976414,871897,668857,1045864,431558,596201,257743,153886,101332,986417,236831,121188,363838,569804,1013308,724990,287516,113648,678913,127674,373243,643591,796911,15642,868669,653338,694487,165929,666759,655905,876122,342639,807974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 649043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 649043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]