SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003531s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44048 LIMIT 1 [ RunTime:0.001996s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44048 [ RunTime:0.004800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218752,312766,210771,76213,136863,351640,174433,486441,538262,615704,597077,6327,365168,301393,915915,190610,887188,808355,954940,78120,1001803,814713,821854,205551,560644,339036,860402,397023,919744,670782,106291,254149,870165,220877,827791,665845,130462,271882,412698,936352,696745,197924,1042661,443691,880974,977235,373882,921709,345037,539835,622209,860840,990714,49947,595795,125626,367610,1047752,327411,872277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]