SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541843 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541843 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195640,196886,46341,1024863,913204,71999,18889,100154,237071,168593,9664,609615,1048023,379107,122136,251361,937824,415885,266124,984496,620402,962655,283597,218127,637437,53400,930229,962143,404084,230538,943309,475646,534138,303242,515297,817574,1018238,761503,306055,79109,109657,706859,912799,119862,369362,429493,127568,163659,452968,373456,840371,948029,974958,440670,956495,116604,1006676,57488,671505,661087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000958s ]