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` = 407628 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407628 [ RunTime:0.002244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149015,39629,506891,259358,742187,355904,302637,692958,945461,535977,147528,902951,440539,580087,798350,404269,2689,84275,279276,513292,371561,72613,547794,172422,1015333,1047063,1170,75994,841656,503250,486111,590536,1034346,629135,393420,175412,157738,737347,632048,905530,466189,594116,337272,200455,836314,798694,871439,706462,435463,539581,856802,147820,566738,164706,221046,252947,452182,341728,169346,261851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]