SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 13210 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 13210 [ RunTime:0.003546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112622,127585,1029967,198672,753267,403866,535682,1034468,696347,144967,552246,852807,821501,293711,542750,532419,291423,499159,640282,834056,951891,373022,756834,343732,198112,160608,276617,272342,565746,779531,483103,802371,541468,709953,433824,831703,196311,410910,371700,172605,426342,770046,340224,1041904,840800,510048,520879,923618,34030,96240,905779,33549,1035989,515463,999547,816330,849067,425605,504952,292706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 13210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 13210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]