SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038547 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038547 [ RunTime:0.002079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621390,105891,503798,817180,998322,800794,893953,160723,702915,389121,101656,384877,341233,499549,632094,625916,558036,990237,305036,575977,226137,384206,894080,384665,264359,770330,313397,100211,369349,5603,67719,398249,216767,545512,745131,878985,760464,906709,796208,582913,676672,326238,700897,629439,153975,300523,1038059,754140,756375,82932,885653,809378,845233,735827,807297,1044195,563978,786845,541337,478515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038547 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038547 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]