SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199480 LIMIT 1 [ RunTime:0.000556s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199480 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005524,480923,638562,300611,528135,655941,161010,877124,76247,856069,775240,1015769,760903,154443,108773,903903,661637,327610,1025484,845403,209230,387993,569444,929405,410477,590479,211784,456514,67728,1030660,482872,166404,62889,725861,735265,126051,448752,187427,333855,981333,766412,657013,379198,282026,411174,34670,329508,1035924,189288,146404,992093,669411,697546,688183,376327,148451,983172,790024,672045,465421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]