SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511911 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511911 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306076,626671,1012725,793079,367213,710407,211381,35356,813003,882038,607763,690411,956697,281296,182876,785144,906082,562792,802577,527364,431267,294495,902671,727910,194820,918678,211972,773020,635520,121869,82049,847522,120102,219287,953111,1032809,895778,754092,504357,863591,1038834,514987,89937,110087,111333,826690,105980,482599,191100,1044793,593307,779807,664332,334435,676931,510789,742647,484319,86258,67522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]