SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040811 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040811 [ RunTime:0.003756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944380,606719,1012683,808214,1002095,191349,830126,340681,225624,24143,15616,457855,763629,654678,931746,177775,165545,718020,399943,484305,67080,1002433,708511,264206,851890,931703,562356,867609,591182,510315,7409,578315,407926,246086,282451,453205,471929,239163,236101,342664,600876,573283,821562,1004588,360096,913884,439005,451491,159373,31443,572943,832740,582752,443703,698835,594188,1007579,347500,313865,893856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]