SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001722s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428916 LIMIT 1 [ RunTime:0.000776s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428916 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544533,377011,410024,249398,1034136,456248,1043772,534318,845196,126660,813688,381392,1034206,189165,337478,238667,318738,477165,426619,859523,590491,238165,841323,125170,934656,337018,572028,579844,89354,545130,656980,122775,801097,811232,230676,229377,694536,476100,943609,740334,698623,877869,269498,783044,854151,705737,889617,554950,219522,111951,37182,421584,592203,945352,17629,711551,12562,778053,362383,16068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]