SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042036 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042036 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728909,713116,982705,279455,701209,800936,272192,165481,324016,122241,762425,702626,522693,1006886,1003914,457359,880210,395492,542171,734238,412183,352992,508053,723970,478039,412509,866015,174890,857290,306009,405429,702425,579056,489855,580760,221804,608309,566763,664882,365103,601030,366304,593634,104527,413932,910749,739869,908751,643916,108191,768014,734134,556552,437264,502739,702756,580418,889151,538611,368755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]