SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001762s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310473 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310473 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55649,417760,1024799,364188,8580,534303,383486,174684,723958,129375,484593,862134,235643,32140,665672,36985,957210,715633,260263,188543,756446,982677,369703,699071,384276,892510,836938,48604,81197,34,552876,945924,239874,16352,491827,101130,295489,228320,233723,31154,501219,68806,559947,542778,812804,871849,750372,146517,335020,612751,320288,866206,265080,680981,315515,538365,518353,287346,214847,1008359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]