SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517425 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517425 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110124,888982,1020474,46125,755376,728733,384760,398533,766117,500093,908320,525771,935773,985487,673818,595517,903643,271942,542080,579713,4239,647438,7275,174282,586226,900275,987164,744113,415912,505656,859947,887320,410046,258099,290635,934849,556053,628935,597262,785369,384948,270848,772409,31838,339601,1044863,932781,690541,594090,130909,204058,487876,820513,916909,789956,243001,899467,155028,321172,830002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000793s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]