SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601409 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601409 [ RunTime:0.003191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763180,411529,759650,285781,919132,815277,829424,233339,534670,623416,542895,431432,1008711,521916,635505,161750,682871,88355,965285,372939,637004,554011,831032,862231,588519,97700,834789,209907,931910,921299,547368,319749,795808,1040294,170182,724920,842987,880813,34001,1014950,1002471,372150,668456,452180,280035,547066,424397,960464,476257,237880,355573,178360,30772,210928,764632,535129,854863,380540,225681,307082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]