SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201921 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201921 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753531,635995,45622,705405,673747,482337,716952,726440,224160,133170,934135,40754,367888,167166,233657,299236,164111,210269,669403,971352,17387,229122,363358,635677,445974,484561,550085,839844,282814,7428,1044785,758488,910240,460135,598333,446152,5758,626458,562317,283824,904019,875241,63976,293917,658736,761855,58542,612938,197909,932116,661406,89575,8039,854718,985119,769224,299061,755796,909939,93181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000997s ]