SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345409 LIMIT 1 [ RunTime:0.000602s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345409 [ RunTime:0.001441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196356,753139,405355,92673,893381,420341,338969,349361,739116,123146,736014,910071,371097,947232,570055,739829,251778,774481,49142,281900,661193,919503,610468,144060,566825,723867,808924,929501,741669,879196,801826,391180,721615,945092,437901,835547,302168,691621,653261,835152,250925,656211,295061,658594,863173,632315,529329,585961,628100,594540,349747,599684,502869,1033521,907299,660442,958716,389896,962120,69713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]