SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546982 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546982 [ RunTime:0.002498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024869,881041,408341,262927,970158,110572,497675,740386,782084,872023,68044,538278,464212,699560,124091,916526,665222,67360,695118,613753,1007682,1012095,561706,491001,278396,793415,111864,749350,584279,332364,978899,3718,626982,795645,288213,1004441,992529,997267,61221,439424,348091,30120,1000823,604880,992572,647854,422417,668574,803681,540121,578156,32883,529249,373576,597866,990006,166272,699503,944171,671644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]