SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511914 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511914 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (747917,112728,21393,199563,597727,458407,524136,776633,130543,544957,167779,1040240,139041,708868,466690,393153,366160,516736,236763,548750,775126,910886,377928,149176,941276,970978,385345,815119,410632,996149,86173,444656,263290,144594,796289,632830,379261,26453,22502,995814,499741,647456,71696,12518,123214,412386,871804,440859,590672,647148,513566,46223,475053,973477,145348,365079,376133,339623,755535,321162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]