SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001919s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336918 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336918 [ RunTime:0.003929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101812,559844,299364,693886,743822,540207,235944,775950,212540,243724,27102,136483,162818,659795,165020,643280,435719,501984,908535,234778,964524,555185,895153,580373,532613,823950,851754,488479,880025,942430,85867,228277,1016147,984368,435572,385079,998529,783440,16050,222742,756226,383057,857139,858863,651195,566159,610621,685202,446399,330181,854944,929485,484893,51486,935551,157569,786306,289056,558658,940483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002927s ]