SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505475 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505475 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265926,449648,145279,381674,799401,847811,627689,752451,589053,637677,900236,391544,276391,455750,663801,872863,771491,983928,306768,467527,87052,87391,466056,863050,527081,501848,64206,789769,607355,804260,615504,38132,925488,346126,502369,255305,286655,783529,307671,403044,144514,59921,234434,636571,327888,207112,498527,213424,777080,37598,12814,814825,798984,72263,307486,622609,132040,231210,291666,450817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]