SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042483 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042483 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672285,429546,445207,285485,729644,768597,319420,243489,232037,368824,1020777,382379,260006,901000,702882,859377,318317,140724,797789,704433,34569,942056,625015,705052,43358,553572,908601,771622,1030555,749237,445714,983330,465814,801048,744062,374561,436119,247143,155130,850352,636672,58470,380723,199364,493712,360379,960877,94291,521142,156243,846057,220636,165654,386978,819082,105711,233322,1015070,769475,30501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]