SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50315 LIMIT 1 [ RunTime:0.002969s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50315 [ RunTime:0.005779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4227,845559,613144,703349,1006635,867823,160792,937419,348731,961902,40527,330185,792280,267570,740068,159933,2481,733924,791126,1002693,90213,629965,515276,56426,106908,41245,437742,203132,281731,935519,31679,302522,578154,980861,597535,590577,23329,569515,284412,590532,849267,469193,184820,393036,171687,413909,136578,527368,768127,525926,198834,786174,519997,345335,907034,64427,444672,232383,21610,1007936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001826s ]