SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004881 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004881 [ RunTime:0.002848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873912,116574,534844,123885,745591,314344,939334,343210,858941,774267,825300,1019351,495248,113027,1002894,415146,669378,632630,142966,813608,65593,537029,126794,572792,218058,375271,124975,712025,589275,523146,238662,131904,993978,673257,366630,173544,208247,821668,110050,778791,310286,740605,504793,200050,529150,108697,702415,59605,60667,302677,42479,328502,930055,487149,723217,722428,552571,374155,801573,179819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]