SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569041 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569041 [ RunTime:0.002424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368114,1017708,122415,248593,801409,415512,150351,949819,284460,965651,611790,739713,717168,1028012,3331,479755,735776,1001369,169668,475144,85333,600907,984388,371390,437073,997113,839204,798561,32743,654925,554102,795106,163342,987148,414318,909695,472298,326283,474310,141271,589075,676698,834012,456013,239272,451259,841145,442754,307175,435879,726638,473917,208072,339634,761353,38147,251512,840597,699076,269772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]