SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 710457 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 710457 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123545,937252,103463,334670,326183,266128,691021,186809,369613,84346,559534,860716,1039565,578950,465133,567961,881670,105755,860368,760315,893726,832958,644165,408451,962327,40050,627457,217156,714442,257457,854018,177255,74457,1033109,478697,379898,243204,846380,319035,526795,302426,865850,932506,582542,128312,1022760,106478,1037626,373736,945983,1453,91307,626946,426654,385578,3421,149579,596980,419609,361214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 710457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 710457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]